Skip to main content
TrustRadius
Qlik Replicate

Qlik Replicate

Overview

What is Qlik Replicate?

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Read more
Recent Reviews

TrustRadius Insights

Qlik Replicate has been widely used by organizations to simplify and streamline their data integration procedures. Users have reported …
Continue reading

Qlik Replicate Review

9 out of 10
December 18, 2021
Incentivized
We use the Replication to replicate data from Different Sources Databases to Different databases. We use from MYSQL to Oracle, Sybase to …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Qlik Replicate?

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Entry-level set up fee?

  • Setup fee required

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

70 people also want pricing

Alternatives Pricing

What is Oracle GoldenGate?

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

What is Hornetsecurity VM Backup?

Hornetsecurity VM Backup (formerly Altaro) is a backup and replication solution for Hyper-V and VMware virtual machines. VM Backup can manage large infrastructures, with the revamped backup repository providing long-term storage and more efficient use of disk space.

Return to navigation

Product Details

What is Qlik Replicate?

Qlik Replicate (formerly Attunity Replicate) enables organizations to accelerate data replication, ingestion and streaming across a variety of heterogeneous databases, data warehouses, and big data platforms. Boasting hundreds of enterprise users worldwide, Qlik Replicate is designed to move data securely and efficiently, with minimal operational impact. Qlik Replicate provides automated, real-time, and universal data integration across all major source endpoints such as databases, systems like SAP, mainframes and Salesforce and delivers data to streaming systems, data warehouses, and data lakes. On-premises and in the cloud.

Qlik Replicate is Enterprise-Ready. It moves data at high speed from source to target and offers a single pane of glass monitoring of data pipelines across the enterprise, all managed through a graphical interface that automates end-to-end replication. With agentless configuration, administrators and data architects can set up, control, and monitor bulk loads and real-time updates with automated change data capture (CDC) at scale.

Qlik Replicate Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of

Qlik Replicate Video

Move data with minimal operational impact.

Qlik Replicate Integrations

Qlik Replicate Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Linux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Informatica RulePoint, Oracle GoldenGate, and HVR are common alternatives for Qlik Replicate.

Reviewers rate Qlik Replicate Productivity 4.7.21 highest, with a score of 8.7.

The most common users of Qlik Replicate are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(49)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Qlik Replicate has been widely used by organizations to simplify and streamline their data integration procedures. Users have reported that this tool effectively transfers data from one place to another, improving overall performance and efficiency in the data integration process. One of the primary use cases for Qlik Replicate is ensuring the accuracy and timeliness of data across various storage systems, which is crucial for organizations relying on real-time data analysis for making informed business decisions. Customers have found value in using Qlik Replicate for data warehousing, disaster recovery, cloud migration, and analytics purposes. This powerful tool allows for data replication, synchronization, and integration across multiple databases and storage systems. Users have successfully replicated operational application data from various sources such as Oracle ERP and Salesforce to Microsoft SQL Server BI systems, enhancing business case data pipelines and supporting reporting and dashboards. Additionally, Qlik Replicate has simplified the process of data warehousing and batch processing of streaming data, making it more convenient for users. Organizations have utilized Qlik Replicate to replicate data from brick-and-mortar source system databases to cloud databases, allowing for direct data querying and supporting various reporting needs. Users have also praised Qlik Replicate for its reliability, intuitive user interface, and support for a variety of sources and targets, making it a preferred choice for replicating on-premises data into the cloud. Overall, customers from different segments and sizes have found Qlik Replicate to be a fantastic tool for achieving seamless data replication with ease of configuration, scalability, and customization options.

Stability and reliability: Users have consistently praised Replicate for its stability and reliability, with minimal alerts, failures, or troubleshooting required. Several reviewers have mentioned this as a key benefit of using the software.

Ease of scalability: Many users have found Replicate to be highly scalable in big data integrated projects, which has had a positive financial impact for them. The ability to easily add new source tables to tasks and ensure synchronization with the latest data has been particularly appreciated by users.

Efficiency in handling large amounts of data: Replicate's ability to efficiently handle and capture large amounts of data has been highlighted by multiple reviewers. This makes it a valuable tool for data replication, warehousing, disaster recovery, cloud migration, and analytics tasks.

Latency Issues: Some users have experienced latency in certain tasks and are unsure of the cause. This issue has been mentioned by multiple reviewers, indicating a recurring problem that affects the overall performance and efficiency of the tool.

Limited Documentation and Error Reporting: Several reviewers have expressed the need for more comprehensive documentation and detailed error reporting in the tool. The lack of sufficient documentation makes it difficult for users to troubleshoot issues effectively, leading to frustration and wasted time trying to find solutions.

Challenging Support Experience: Users have voiced their desire for more agile and efficient support. They find the current support experience lacking in responsiveness and quality, highlighting areas that require improvement such as faster response times, better communication, and more knowledgeable support staff.

Users have made several recommendations based on their experiences with Qlik Replicate. Firstly, they suggest trying Qlik Replicate for change data capture (CDC) needs and conducting a proof of concept (POC) to see the benefits and suitability of the software.

Secondly, it is advised to check the hardware requirements, install recommended resources, and test the software in a representative environment with volume. Users also recommend considering any pre-requests, security requirements, and logging setup.

Lastly, many users find Qlik Replicate worth the cost and believe it is an excellent tool for reducing stress during data replication or loading. They suggest getting a demo of the software to better understand its capabilities and determine if it suits the company's needs.

Attribute Ratings

Reviews

(1-17 of 17)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
In my previous company, we used Qlik Replicate as the primary tool for near-real-time data integration. The flexibility it provides allows you to perform simple ETL tasks directly within the software. This was crucial for our retail company with an ecommerce platform, as we needed to fulfill orders quickly and align stock information almost immediately.
  • Real time integration
  • User experience
  • Performance
  • Data mapping
  • Integration with external custom code
As a retail company, it is crucial to have consistent and accurate stock information across all systems. Qlik Replicate is a useful tool for achieving this goal, as it efficiently replicates data in near-real-time. However, it may not be the best option for data that requires pre-aggregation before replication. In such cases, using another tool or Qlik View/Sense script may be more appropriate and avoid the need for replicate.
Fernando Tonial | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Qlik Replicate is used to data integration allows organization to replicate, synchronize, and integrate data across multiple databases, data warehouses, and other data storage systems.

The main use case for Qlik Replicate is to ensure that data is accurate and up-to-date across my organization's various data storage systems. This is particularly important for organizations that rely on real-time data analysis to inform business decisions, as Qlik Replicate ensures that all relevant data is available for analysis in a timely manner. Some common ways that Qlik Replicate is used include:Data Warehousing: Qlik Replicate can be used to replicate data from operational databases to data warehouses for analysis.Disaster Recovery: Qlik Replicate can be used to replicate data in real-time to a secondary location for disaster recovery purposes.Cloud Migration: Qlik Replicate can be used to move data from on-premises systems to cloud-based systems.Analytics: Qlik Replicate can be used to move data from various sources into a single location for analysis.Overall, Qlik Replicate is a versatile tool that can be used to ensure that data is accurate and up-to-date across an organization's various data storage systems.
  • Data Warehousing: Qlik Replicate can be used to replicate data from operational databases to data warehouses for analysis.
  • Disaster Recovery: Qlik Replicate can be used to replicate data in real-time to a secondary location for disaster recovery purposes.
  • Cloud Migration: Qlik Replicate can be used to move data from on-premises systems to cloud-based systems.
  • Analytics: Qlik Replicate can be used to move data from various sources into a single location for analysis.
  • More detailed documentation with errors that occurred in the tool.
  • More agile and efficient support.
  • It works best if you also use other Qlik products.
  • Few APi integrations are not compatible
Qlik Replicate works very well with relational data platforms, both on premise and in the cloud, for example Oracle, SQL Server, PostgreSQL, MySQL and others, it also works very well with DB2.
If the data source is MongoDB, it is more complicated and currently there is no possibility of sending data to MongoDB.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate to replicate data between our cloud-based datamart and on-prem applications.
  • Replication rate
  • Performance
  • Easy to configure
  • Pricing
  • Support
Replication between datamart and applications.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate (formerly Attunity Replicate) to load data from multiple on-prem sources (Oracle and SQL Server DBs) into the Cloud Data warehouse in Azure cloud. Software is easy to set up and configure. Software is very reliable, works great, has a scheduler that some other competitors don't have as well as a job notification process. UI is very intuitive and as long as there are no tricky transformations are deployed, users don't need any training. For heavy-duty transformations to implement, it gets tricky, and transformation functions are not obvious at times. The software supports a variety of sources and targets and works better than competitors. We run daily/weekly/monthly jobs to replicate on-prem data into the cloud and it works very well. We also have a number of near real-time replication jobs and [they] work well too.
  • Performing near-real time replications for 14TB SQL Server DB into Azure EDW
  • Performing near real time replications from 28TB on-prem Oracle DB into Azure EDW
  • Looking for Qlik to support CDS view replications from S4 HANA, both full loads and CDC
  • Better document data transformation functionality
Good and reliable software
Doug Thomas | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate for the replication of data in our brick-and-mortar source system databases to our cloud database. Our source systems are on many servers and we replicate them near real-time to a central cloud database. In our central cloud database, our users (product, data scientists, business analysts, etc.) can query the data directly. We also maintain data marts against the replicated data that are used by many different areas of our business as well. With Qlik Replicate we can tune replication to be cost-effective per data set. And, with Qlik Enterprise Manager we can manage and analyze all replication tasks in a single UI no matter how many Qlik Replicate servers we may have and, whether they are on Linux or Windows.
  • Many different source to target replication options
  • Common UI on Linux and Windows
  • Lots of task tuning options
  • Robust API (Enterprise Manager)
  • Easy to use UI
  • Robust scheduler
  • I would like to be able to keep task history beyond 30 days for viewing in analytics.
  • I would like integrations to more than email. Say, MSFT Teams channels.
  • Logging is great. With known resolutions to errors that are encountered it would be great to have more detailed context-sensitive help for faster resolution of errors. Especially if they are well known in the community.
  • I would like integration to source control for our at least our tasks.
We've found Qlik Replicate is well suited for near-real-time data replication from brick and mortar databases to cloud providers. We've tried a number of different options and found Qlik Replicate to be the one product that could handle all of our use cases without any issues. We also minimize any custom code needs as well as administration and application support needs.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We first used Qlik Replicate to replicate data from the Oracle ERP system to a Microsoft SQL Server BI system. We have also started using Qlik Replicate to replicate from Salesforce to the Microsoft SQL Server BI system.
  • Flexibility for creating multiple tasks for grouping related tables
  • Table level filters
  • The scheduler feature has been very useful
  • The scheduler, while useful, has issues when trying to create or adjust a schedule more recent than the current time UTC. That is the one thing I would really like to see improved.
Qlik Replicate is very good at cross platform replication such as from Oracle to Microsoft SQL Server.
Rajesh Chauhan | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Operational Application Data (Oracle + SQL Server) replication to Data Lake (SnowFlake). The core capability is to replicate Operational data in real/batched mode to Data Lake as core to servicing enterprise data hub which enables Enterprise Reporting, Data Warehouse, and other data as application usage (Data Innovation and sharing at the edge).
  • Real time replication using Database Logs
  • Speed to setup and make it operational
  • Speed to business value realization
  • Applying the solution to SAP/HANA and other databases as source
  • Connectors/Adaptors to Tier 1 Cloud applications
  • Data type portability across multiple databases
A great tool to data replication solution for Oracle/SQLServers/etc. Fails to replicate data from SAP HANA via CDS Views and/or using SAP ODP framework. Only SAP HANA log base replication is supported which is not certified by SAP nor guaranteed for row tables. Real easy to get it set up and start realizing business value.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Qlik Replicate/Attunity is being used to replicate SQL server database to our cloud Snowflake database in near real time. It is being used to create strategic datamarts and dashboards to the whole organization and allows us to have access to the data without impacting the ERP production server with live queries.
  • Replication
  • Reliability
  • Incremental Speed
  • Full reload speed
  • Features such as parallel processing are not working
  • If connection is lost, a full reload is required to re-sync
Good for database to database replication. Salesforce connector did not work last I checked as it did not handle custom fields well and was erroring out due to row counts.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Qlik's solutions have helped make financial data more easily accessible across orgs and has provided the additional functionality my team needs to provide real-time analytics in a fast-pace Tech environment. The platforms used prior to Qlik were not as intuitive, less reliable and much slower than the solutions provided by Qlik.
  • intuitive interface
  • reliable data
  • helpful support when needed
  • smoother interface
  • faster load times
  • enhanced funtionality
There are many applications where Qlik's solutions have helped my team considerably, most notably when we were tasked with providing detailed analysis with a short turn-around time (Qlik's quick interface allowed us to complete the task without delay). A scenario where Qlik is not ideal is when it's used by an untrained or inexperienced user.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Qlik Replicate is being used as a Data Ingestion layer from enterprise applications and source systems like ERP, CRM by directly scanning the backend DB logs on a real-time basis. Qlik Replicate is used specifically by IT for Data Warehousing and BI reporting. It helps resolve not running a batch-based ETL process to ingest the data into the Data Warehouse staging layers avoiding an expensive overhead to manage additional time-bound processes.
  • Data ingestion.
  • Real-time analytics.
  • Replicating/syncing source data (CRUD operations).
Qlik Replicate is well suited for building data pipelines to replace ETL processing, this is extremely useful when the source datasets lack identification of change records. Instead of ETL doing a row by row comparison which is more expensive Qlik Replicate does the delta changes by using watermark from the database logs eliminating the need any additional processing for sourcing the data. It is more appropriate where the need arises to ingest the source data as its generated for faster ingestion and analysis (real-time analytics).
Reid DeWolfe | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Replicate to ETL data from on our prem instances to cloud databases hosted by both ourselves and our clients. Our clients benefit greatly from having near-real-time data from our application available to them for analysis and integration purposes. Using Replicate allowed us to avoid developing our own custom processes and tooling for automating the creation of these ETL processes.
  • Reliably and quickly delivers data to and from a wide variety of endpoints.
  • Support staff responds quickly and helpfully to support requests and questions.
  • API coverage in Enterprise Manager allows for automation of administrative tasks.
  • The base Replicate web GUI is lacking. If you have dozens or more tasks, it's hard to get a sense of how they're performing. Enterprise Manager solves all of these problems but is a separate install.
  • The support portal is extremely difficult to navigate. It's hard to track down exactly what you're looking for.
  • It would be helpful to have better documentation and example queries for the tables in the Enterprise Manager analytics database.
  • Destination databases that don't support common DDL commands behave unpredictably. And the replication of schema changes isn't consistent.
It's a great solution if you have relatively static schemas and a limited number of tasks going to a small number of distinct endpoint types. In those situations, it can easily handle large volumes of data changes given appropriate host resources. However, once you end up with a larger number of tasks with a diversity of destination endpoint types Enterprise Manager becomes essential. Automating tasks via API is needed to keep management of the tool sustainable.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
As part of our migration from an on-premises Netezza Enterprise Data Warehouse to Snowflake we also replaced dozens of lengthy ETL extract processes with Qlik Replicate. This gave us one location with multiple system's data in near real-time for operational reporting as well as the ability to simply transform and load data into the Data Warehouse without the lengthy extract process. As a result, we start the process later in the day and finish much earlier despite continuing to add more data and complex processing.
  • Loads data from ERP systems.
  • Non journaled/logged sources can be run as full load only processes via API calls.
  • Monitoring and alerting.
  • Ability to enable source system owners to start and stop tasks for their maintenance windows.
  • A wizard for partitions for parallel loading.
  • Better way to analyze latency.
  • Better documentation for using flat files as a source.
Its great for loading data from ERP databases (iSeries, Oracle, DB2, SQL Server). Not that great for Netezza. Does minimal DDL (no unique constraints other than PK, no foreign keys).
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is used across the company to replicate ecommerce, ERP, finance and marketing data. In lieu of complicated data flow, it enables us to have a real-time data using simple method which are convenient for users. It can also be easily monitored and users will be notified if there is any kind of issue in the replication.
  • Low latency.
  • High volume data.
  • Easiness of monitoring.
  • Alerting mechanism.
  • Less impact on the source.
  • Hourly schedule.
  • Source to target comparison.
  • Renaming tasks.
We had to develop a database and make it available to users as soon as possible. If we used other tools to replicate the data, it might take longer time. But by using QLIK, we were able to set up the target database with less effort and less time. The precision is amazing and the latency was very minimum.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use it to replicate data from SQL Server to Snowflake real time.
It's being used by multiple departments in the whole organization.
It helps in full load and replication.
  • Change processing option to replicate real time
  • Various connection end points
  • Load monitor windows
  • Easy to learn and use
  • Error message clarity is lacking and not easy to understand
  • Logs aren't user friendly to read
  • No downloadable client
Not useful if the source is restoring often.
Doesn't do well with new connection end points like Salesforce.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate in one specific vertical within our larger organization. We are using it to copy transactional tables from our CRM database into a data warehouse so that we can build a business intelligence suite on top of that data in an OLAP database. Qlik Replicate allows us to easily copy that data without our having to build our own custom, real-time ETL processes.
  • Replicate is extremely stable and does not generate a lot of alerts/failures/issues that take up time to troubleshoot.
  • It is very easy to add new source tables to a Replicate task so that we're always in sync with new data available from the CRM.
  • It's nice that Qlik Replicate also allows you to create a job to stop and then restart your tasks during maintenance windows that occur on both the source and target systems.
  • I wish there was a way to give the user the option to decide if changing a particular task setting actually requires a reload of the target table. Too many changes or modifications within the task settings require you to reload a table and if the target database and source database do not have the same data retention policies then you risk losing data and you have to account for that when changing task settings.
  • From time to time a particular task begins to build up latency where it becomes 2,3 or 4 hours behind the source system. It's never really clear why that is occurring and it may be impossible to know exactly but I wish there was a way to know that it was due to activity happening at the source or the target.
We don't really use a lot of the more advanced features of Qlik Replicate (like transformations) but I feel like Qlik Replicate is very good at the simple 1:1 replication of source to target. It provides you a way to view change tables to see how/when attributes within source tables changed. It's great for business groups that may not know as much about building an ETL but it would get the data they need into a non-production environment to query/investigate/report on certain aspects of their business without the necessity of a giant IT budget.
David Fisher | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Qlik Replicate is used to keep internal and external data in sync for the Interstate Batteries data lake running on Snowflake. It is used across the entire organization, even at the officer level. It allows us to have a reliable single source of truth for the various reporting needs at Interstate.
  • Replicate data from external sources to an internal data lake.
  • Keep data in sync from one source to another collective source, regardless of the sources in question.
  • Perform near-real-time tasks and replications as required, but this is adjustable because some of our replications are only meant to provide data that is not less than 24 hours old.
  • In the beginning of our partnership, support was a real challenge. It has improved over the last three years, but there is still more room for improvement.
  • The learning curve is steep and it is hard to find a replication specialist, so Interstate was forced to train someone in house, and there were growing pains there.
  • Cost is always an area for improvement, although, in my opinion, at least for Interstate, cost is reasonable.
It is a good solution to achieve the purpose of keeping two disparate data sources in sync with each other. Our environment is small to medium size, so it is hard for me to say how well it scales. The rate of replication is adjustable and this is one way to improve performance.
Rich Fox | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We currently use it for one department. We have a centralized application that we use Qlik Replicate for bidirectional replication (hub and spoke) to sync up data with 90 sites, filtering so only transactional data related to the target site is replicated. This permits an application that was not developed for a WAN environment to be utilized locally at branches without issues of slowness or downtime caused by the network.
  • Very low latency with large transaction volume.
  • Central management console (AEM) for monitoring and managing many tasks.
  • No daily maintenance. Process is basically on autopilot.
  • Quick and easy to create or modify tasks.
  • Filtering data had some unwanted side effects.
  • No ability to do full loads with bidirectional replication.
  • Ability to use LOBs with upsert mode.
  • No ability to push/pull from web services/APIs
We have had very good luck using Replicate to sync up tables from one server to another. The two main reasons we are doing this are for data warehousing and for turning a local application into an enterprise solution.
Return to navigation